CREATE TABLE [dbo].[tb_EstudiosParcialesAudit]
(
[idEstudioParcialAudit] [int] NOT NULL IDENTITY(1, 1),
[idEstudioParcial] [int] NOT NULL,
[Agente] [int] NOT NULL,
[Titulo] [int] NOT NULL,
[Entidad] [int] NOT NULL,
[MateriasPlan] [int] NOT NULL,
[CantidadMateriasAprobadas] [int] NOT NULL,
[TotalMatPedagogicasPlan] [int] NULL,
[CantidadMatPedagogicasAprobadas] [int] NULL,
[FechaDeCarga9] [datetime] NOT NULL CONSTRAINT [DF_tb_EstudiosParcialesAudit_FechaDeCarga9] DEFAULT (getdate()),
[GrupoIncumbencias] [int] NOT NULL,
[FechaPresentacion] [datetime] NULL,
[Operacion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FechaOperacion] [datetime] NOT NULL,
[UsuarioNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__tb_EstudiosParcialesAudit__Usuar__7751F054] DEFAULT (suser_sname())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_EstudiosParcialesAudit] ADD CONSTRAINT [PK_tb_EstudiosParcialesAudit] PRIMARY KEY CLUSTERED  ([idEstudioParcialAudit]) ON [PRIMARY]
GO
